[dbo].[Affect_Cert_Register

[dbo].[Affect_Cert_Register_ie]

SQLServer > iMIS1521GA > Tables > dbo.Affect_Cert_Register_ie

Properties
Columns
SQL Script
Uses

Property	Value
Heap
Row Count	0
Created	10:31:13 AM Tuesday, March 02, 2010
Last Modified	10:31:13 AM Tuesday, March 02, 2010

Columns

Name	Data Type	Max Length (Bytes)	Default
SEQN	int	4	((0))
STUDENT_ID	varchar(10)	10	('')
BT_ID	varchar(10)	10	('')

SQL Script

CREATE TABLE [dbo].[Affect_Cert_Register_ie]
(
[SEQN] [int] NOT NULL CONSTRAINT [DF_Affect_Cert_Register_ie_SEQN] DEFAULT ((0)),
[STUDENT_ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Affect_Cert_Register_ie_STUDENT_ID] DEFAULT (''),
[BT_ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Affect_Cert_Register_ie_BT_ID] DEFAULT ('')
) ON [PRIMARY]

GO

Uses